﻿CREATE TABLE [dbo].[Mobile_JobCandidate] (
    [CandidateId]  UNIQUEIDENTIFIER CONSTRAINT [DF_Mobile_JobCandidate_CandidateId] DEFAULT (newid()) NOT NULL,
    [Name]         NVARCHAR (100)   NULL,
    [Handphone]    NVARCHAR (50)    NULL,
    [Gender]       NVARCHAR (50)    NULL,
    [ICNo]         NVARCHAR (50)    NULL,
    [HomeAddress]  NVARCHAR (500)   NULL,
    [Position]     NVARCHAR (200)   NULL,
    [CreateDate]   DATETIME         CONSTRAINT [DF_Mobile_JobCandidate_CreateDate] DEFAULT (getdate()) NOT NULL,
    [StatusDelete] TINYINT          CONSTRAINT [ColumnDefault_8d2206f5-4293-477c-83a0-b5c561d58f17] DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PrimaryKey_5e134469-2537-4f65-8c1e-d70cbb45f13c] PRIMARY KEY CLUSTERED ([CandidateId] ASC)
);


GO
CREATE NONCLUSTERED INDEX [IX_Mobile_JobCandidate_0]
    ON [dbo].[Mobile_JobCandidate]([CandidateId] ASC);

